<%--
  Created by IntelliJ IDEA.
  User: Gao
  Date: 2024/4/15
  Time: 14:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link rel="stylesheet" href="static/layui/css/layui.css">
    <script src="/static/jquery-2.1.4.js" type="text/javascript" charset="utf-8"></script>
    <script src="/static/layui/layui.js" type="text/javascript" charset="utf-8"></script>
    <script src="/static/mylayer.js" type="text/javascript" charset="utf-8"></script>
</head>
<body>
    <%--搜索form表单--%>
    <form class="layui-form layui-row layui-col-space16">
        用户名：
        <div class="layui-inline layui-input-wrap">
            <div class="layui-input-prefix">
                <i class="layui-icon layui-icon-username"></i>
            </div>
            <input type="text" name="name" value="" class="layui-input" lay-affix="clear">
        </div>
        地址：
        <div class="layui-inline layui-input-wrap">
            <input type="text" name="address" lay-affix="clear" class="layui-input">
        </div>
        时间：
        <div class="layui-inline layui-input-wrap">
            <input type="text" name="time" lay-affix="clear" class="layui-input">
        </div>
        <div class="layui-inline">
            <button class="layui-btn" lay-submit lay-filter="submitSearch">Search</button>
            <button type="reset" class="layui-btn layui-btn-primary">Clear</button>
        </div>
    </form>
    <table class="layui-hide" id="test" lay-filter="test"></table>
    <%--头部工具条--%>
    <script id="toolbarDemo" type="text/html" >
        <div class="layui-btn-container">
            <button class="layui-btn layui-btn-sm" lay-event="add">添加</button>
            <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="deleteAll">批量删除</button>
        </div>
    </script>
    <%--右侧工具条--%>
    <script type="text/html" id="barDemo">
        <div class="layui-clear-space">
            <a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="delete">删除</a>
            <a class="layui-btn layui-btn-xs" lay-event="update">编辑</a>
        </div>
    </script>
    <%--添加form表单--%>
    <div id="addForm" style="display:none;">
        <form class="layui-form" action="">
            <div class="layui-form-item">
                <label class="layui-form-label">班级名</label>
                <div class="layui-input-block">
                    <input type="text" name="name" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">地址</label>
                <div class="layui-input-block">
                    <input type="text" name="address" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">时间</label>
                <div class="layui-input-block">
                    <input type="text" name="time" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <div class="layui-input-block">
                    <button type="submit" class="layui-btn" lay-submit lay-filter="submitAdd">立即提交</button>
                    <button type="reset" class="layui-btn layui-btn-primary">重置</button>
                </div>
            </div>
        </form>
    </div>
    <%--修改form表单--%>
    <div id="updateForm" style="display:none;">
        <form class="layui-form" lay-filter="updateFormFilter" action="">
            <input type="hidden" name="id">
            <div class="layui-form-item">
                <label class="layui-form-label">班级名</label>
                <div class="layui-input-block">
                    <input type="text" name="name" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">地址</label>
                <div class="layui-input-block">
                    <input type="text" name="address" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">时间</label>
                <div class="layui-input-block">
                    <input type="text" name="time" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <div class="layui-input-block">
                    <button type="submit" class="layui-btn" lay-submit lay-filter="submitUpdate">立即提交</button>
                    <button type="reset" class="layui-btn layui-btn-primary">重置</button>
                </div>
            </div>
        </form>
    </div>

    <script>
        layui.use(['table', 'form'], function(){
            var form = layui.form;
            var table = layui.table;
            // 创建渲染实例
            table.render({
                elem: '#test',
                id: 'tableId',
                url:'/banji?method=selectByPage',
                toolbar: '#toolbarDemo',
                cols: [[
                    {type: 'checkbox', fixed: 'left'},
                    {field:'id', title: 'ID', sort: true},
                    {field:'name', title: '班级名'},
                    {field:'address', title: '地址'},
                    {field:'time', title: '入学时间', sort: true},
                    {fixed: 'right', title:'操作', width: 134, minWidth: 125, toolbar: '#barDemo'}
                ]],
                page: true
            });

            // 搜索提交
            form.on('submit(submitSearch)', function(data){
                var field = data.field; // 获得表单字段
                // 执行搜索重载
                table.reload('tableId', {
                    page: {
                        curr: 1 // 重新从第 1 页开始
                    },
                    where: field // 搜索的字段
                    //http://localhost:8080/banji?method=selectByPage&page=1&limit=10&name=zhansgsan&address=5&time=2014
                });
                return false; // 阻止默认 form 跳转
            });

            // 头部工具栏事件
            table.on('toolbar(test)', function(obj){
                var id = obj.config.id;
                var checkStatus = table.checkStatus(id);
                var othis = lay(this);
                switch(obj.event){
                    case 'add':
                        var index = layer.open({
                            type: 1,
                            title: '添加数据',
                            area: ['500px', '300px'], // 宽高
                            content: $('#addForm').html()
                        });

                        // 绑定提交事件
                        form.on('submit(submitAdd)', function(data){
                            var field = data.field; // 获取表单字段值
                            console.log(data);
                            // 此处可执行 Ajax 等操作
                            $.post(
                                '/banji?method=add',
                                field,  //{name: 'zhyangsan', address: 'fdfd', time: 'fd'}
                                function(result) {
                                    console.log(result);
                                    if (result.code == 0) {
                                        mylayer.okMsg(result.msg);
                                        layer.close(index);
                                        table.reload('tableId');
                                    } else {
                                        mylayer.errorMsg(result.msg);
                                    }
                                },
                                'json'
                            );
                            return false; // 阻止默认 form 跳转
                        });
                        break;
                    case 'deleteAll':
                        var data = checkStatus.data;
                        //[{"id":2,"name":"Java1812","address":"ddf","time":"232"},{"id":3,"name":"Java1903","address":"34","time":"323"}]
                        var ids = new Array();
                        $(data).each(function () {
                            ids.push(this.id);
                        })
                        //[2,4]
                        layer.confirm(
                            '您确认要删除么?',
                            {icon : 3},
                            function(index){
                                $.post(
                                    '/banji?method=deleteAll',
                                    {'ids': ids},
                                    function (result) {
                                        console.log(result);
                                        if (result.code == 0) {
                                            mylayer.okMsg(result.msg);
                                            //删除成功之后刷新表格，展示最新数据
                                            table.reload('tableId');
                                        } else {
                                            mylayer.errorMsg(result.msg);
                                        }
                                    },
                                    'json'
                                );
                            }
                        );
                        break;
                    case 'LAYTABLE_TIPS':
                        layer.alert('自定义工具栏图标按钮');
                        break;
                };
            });

            // 触发单元格工具事件
            table.on('tool(test)', function(obj){ // 双击 toolDouble
                var data = obj.data; // 获得当前行数据
                console.log(obj);
                //{"id": 1,"name": "Java1807","address": "dfdf","time": "3434"}
                console.log(obj.data);
                if(obj.event === 'delete'){
                    layer.confirm(
                        '您确认要删除么?',
                        {icon : 3},
                        function(index){
                            $.post(
                                '/banji?method=deleteById',
                                {'id': data.id},
                                function (result) {
                                    console.log(result);
                                    if (result.code == 0) {
                                        mylayer.okMsg(result.msg);
                                        //删除成功之后刷新表格，展示最新数据
                                        table.reload('tableId');
                                    } else {
                                        mylayer.errorMsg(result.msg);
                                    }
                                },
                                'json'
                            );
                        }
                    );
                } else if(obj.event === 'update'){
                    var index = layer.open({
                        type: 1,
                        title: '编辑数据',
                        area: ['500px', '300px'], // 宽高
                        content: $('#updateForm').html(),
                        success: function () {
                            //form.val有两个参数，第一个是form表单的lay-filter名字，
                            //第二个参数是json对象：{"id": 1,"name": "Java1807","address": "dfdf","time": "3434"}
                            //将第二个参数的值按照“名字”映射到form表单中
                            //form.val('updateFormFilter', data);
                            $.post(
                                '/banji?method=selectById',
                                {'id': data.id},
                                function (result) {
                                    if (result.code == 0) {
                                        form.val('updateFormFilter', result.data);
                                    }
                                },
                                'json'
                            );
                        }
                    });

                    // 绑定提交事件
                    form.on('submit(submitUpdate)', function(data){
                        var field = data.field; // 获取表单字段值
                        console.log(data);
                        // 此处可执行 Ajax 等操作
                        $.post(
                            '/banji?method=update',
                            field,  //{name: 'zhyangsan', address: 'fdfd', time: 'fd'}
                            function(result) {
                                console.log(result);
                                if (result.code == 0) {
                                    mylayer.okMsg(result.msg);
                                    layer.close(index);
                                    table.reload('tableId');
                                } else {
                                    mylayer.errorMsg(result.msg);
                                }
                            },
                            'json'
                        );
                        return false; // 阻止默认 form 跳转
                    });
                }
            });

        });
    </script>
</body>
</html>
